# coding: utf-8
from sqlalchemy import Column, DateTime, Integer, String
from flask_sqlalchemy import SQLAlchemy


db = SQLAlchemy()


class UserMsg(db.Model):
    __tablename__ = 'user_msg'

    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50))
    password = db.Column(db.String(255))
    email = db.Column(db.String(255))
    name = db.Column(db.String(255))
    sex = db.Column(db.String(2))
    address = db.Column(db.String(255))
    token = db.Column(db.String(500))
    register_time = db.Column(db.DateTime)
    update_time = db.Column(db.DateTime)
    delete_time = db.Column(db.DateTime)
    is_delete = db.Column(db.String(1))
